SELECT * FROM london_stages WHERE eventid IN (38080, 38095, 38104, 38125, 38130, 38140, 38155, 38169, 38185, 38199, 38238, 38252, 38264, 38504, 38518, 38532, 38631, 38641, 38646, 38660, 38665, 38708, 38797, 38927, 38941, 38955, 38969, 38978, 38992, 38997, 39040, 39053, 39064, 39085, 39097, 39112, 39125, 39134, 39139, 39153, 39168, 39186, 39204, 39221, 39227, 39238, 39256, 39272, 39279, 39290, 39295, 39311, 39319, 39332, 39344, 39352, 39356, 39358, 39367, 39373, 40110, 40124, 40138, 40152, 40166, 40177, 40191, 40206, 40220, 40246, 40404, 40414, 40429, 40434, 40439, 40442, 40456, 40464, 40470, 40477, 40485, 41220, 41225, 41267, 41307, 41362, 41377, 41391, 41395, 41400, 41405, 41409, 41418, 41426, 41431, 41443, 41448, 41456, 41463, 41472, 41482, 41521, 41530, 41540, 41545, 41550, 41560, 41565, 41574, 41578, 41581, 41587, 41591, 41593, 41596, 41599, 41602, 41605, 42054, 42180, 42188, 42340, 42343, 42345, 42348, 42350, 42352, 42354, 42357, 42359, 42362, 42364, 42367, 42369, 42374, 42379, 42381, 42383, 42412, 42420, 42425, 42435, 42442, 42452, 42463, 42472, 42481, 42486, 42501, 42506, 42510, 42530, 42541, 42549, 42551, 42554, 42561, 42607, 42620, 42668, 42689, 42712, 42801, 42804, 42807, 42813, 42838, 42840, 42842, 42844, 42846, 42847, 42848, 42850, 42852, 42853, 42870, 42880, 42889, 42898, 42906, 42920, 42928, 42942, 42952, 42968, 43003, 43069, 43095, 43124, 43167, 43277, 43322, 43330, 43333, 43337, 43347, 43350, 43352, 43355, 43395, 43399, 43400, 43405, 43929, 43938, 43942, 43944, 43948, 43951, 43967, 43970, 43975, 43977, 43979, 43981, 43985, 43986, 43988, 43991, 43992, 44007, 44009, 44013, 44015, 44021, 44219, 44228, 44231, 44240, 44245, 44254, 44307, 44312, 44316, 44320, 44329, 44333, 44338, 44351, 44375, 44385, 44390, 44400, 44415, 44430, 44440, 44455, 44460, 44472, 44476, 44478, 44480, 44481, 44482, 44483, 44491, 44500, 44503, 44504, 44508, 44511, 44517, 44521, 44526, 44527, 44532, 44533, 44535, 44539, 44547, 44556, 44557, 44558, 44559, 44560, 44561, 44563, 44564, 44565, 44567, 44573, 44576, 44579, 44580, 44581, 44582, 44585, 44586, 44744, 44753, 44758, 44767, 44772, 44781, 44792, 44820, 44825, 44837, 44858, 44864, 44937, 44942, 44947, 44953, 44962, 44967, 44976, 44981, 44987, 44993, 44999, 45005, 45014, 45033, 45042, 45046, 45052, 45058, 45059, 45061, 45066, 45067, 45070, 45072, 45075, 45079, 45080, 45081, 45082, 45092, 45094, 45095, 45097, 45099, 45102, 45116, 45125, 45126, 45132, 45253, 45258, 45267, 45272, 45281, 45298, 45303, 45308, 45317, 45357, 45362, 45366, 45370, 45382, 45391, 45395, 45400, 45404, 45408, 45413, 45417, 45421, 45426, 45430, 45434, 45447, 45452, 45467, 45507, 45527, 46008, 46021, 46071, 46076, 46086, 46091, 46096, 46101, 46119, 46131, 46434, 46439, 46444, 46453, 46458, 46467, 46472, 46479, 46484, 46493, 46498, 46507, 46512, 46520, 46525, 46567, 46689, 46703, 47205, 47215, 47221, 47245, 47262, 47271, 47274, 47280, 47286, 47292, 47298, 47305, 47308, 47310, 47317, 47324, 47332, 47336, 47343, 47347, 47354, 47358, 47364) GROUP BY eventid ORDER BY eventdate ASC OPTION

Result Options

Download:
JSON XML CSV

Search Filters

Event

Date Range
Start
End

Performance

?
Filter by Performance Type










Cast

?

Keyword

?

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750207; End II: New Ballet-S. Vallouis, Mlle Vallouis

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750307

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750307

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750307

Performances

Mainpiece Title: I Viaggiatori Ridicoli

Dance: As17750311

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: I: La Mascherata-Lany, Vallouis, Mlle Vallouis; II: Silvie-Vallouis, Mlle Vallouis; III: Heroic Historic Ballet-Lany, Vallouis, Mlle Vallouis (without the Chaconnes)

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: I: Grand Chaconne-Mlle Baccelli; II: Silvie-Vallouis, Mlle Vallouis; III: La Bal Masquer-Lany, Vallouis, Mlle Vallouis, Mlle Baccelli; With a Pas de Deux-Henery; an Allemande-Henery, Mlle Sophie

Performances

Mainpiece Title: I Viaggiatori Ridicoli

Dance: I: New Serious Ballet-; with a Pas de Deux-Vallouis, Mlle Vallouis; also a Grand Chaconne-Vallouis; II: New Ballet-; with a Pas de Deux-Vitalba, Mlle Sophie; a Louvre-Mlle Baccelli; End Opera: Champetre Comique-Lany, Vallouis, Mlle Vallouis, Asselin, Mlle Sophie, Vallouis@le@cadet

Performances

Mainpiece Title: I Viaggiatori Ridicoli

Dance: As17750425

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750506

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: I: Chaconne-Mlle Baccelli; (by Particular Desire) a Minuet-M and Mme Vallouis; II: Ballet Pastorale et Pantomime-M and Mme Vallouis

Ballet: End Opera: Grand Ballet Tragique called Oreste et Electre. Oreste-Vallouis; Electre-Mme Vallouis; Clytemnestre-Mlle Baccelli

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750530

Performances

Mainpiece Title: La Marchesa Giardiniera

Dance: As17750606

Performances

Mainpiece Title: Il Bacio

Dance: I: Serious Ballet-Fierville, Mlle Bacelli; II: Les Evenemens Imprevues-M N. N., Helm, Mlle Tinti, Mlle Sophie; End Opera: La Generosite de Scipion-N. N., Fierville, Mlle Baccelli

Performances

Mainpiece Title: Il Bacio

Dance: As17760109

Performances

Mainpiece Title: Il Bacio

Dance: I: Les Evenemens Imprevues, as17760120; Ballet Pastoral, as17760120; La Generosite de Scipion-

Performances

Mainpiece Title: L'isola D'amore

Dance: I: Diane et Endymion Endymion-Fierville, Diane Mlle Baccelli; Une Bergere-Mlle Sophie; II: La Fete du Village, as17760224

Ballet: End Opera: Astolphedans L'ile de Alcine. Astolphe-Fierville; Alcine-Mlle Baccelli; Helm; Mlle Sophie

Performances

Mainpiece Title: L'isola D'amore

Dance: I: Les Deux Soeurs, as17760203; II: La Fete du Village, as17760224

Ballet: End Opera: Astolphe. As17760312

Performances

Mainpiece Title: L'isola D'amore

Dance: After the Overture: A New Ballet Incident to the Opera call'd Le Retour des Matelotes-Helm, Mlle Sophie, Sga Tinti; End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: L'isola D'amore

Dance: End Overture: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: Alcina

Dance: I: Les Deux Soeurs, as17760203; II: Ballet Pastoral-S. Vallouy, Mme Vallouy, Helm, Mlle Sophie; Pigmalion, as17760307

Performances

Mainpiece Title: La Serva Padrona

Afterpiece Title: L'Isola D'Amore

Dance: After the Intermezzo: Le Retour des Matelotes, as17760319 End I: La Fete du Village, as17760224; End Opera: Diane et Endymion, as17760312

Performances

Mainpiece Title: L'isola D'amore

Dance: After Overture: Le Minuet a la Cour-the two Vallouys; End I: Diane et Endymion, as17760312 End Opera: La Fete du Village, as17760224

Performances

Mainpiece Title: La Fraschetana

Dance: End I: Les Amusemens Champetres, as17761102; End II: Grand Serious Ballet, as17761102; End Opera: a new Ballet, Demi-caractere, Les Chasseurs-Mons Vallouy, Mme Vallouy, Sg and Sga Zuchelli, Simonin Vallouy?@le@cadet